// app/api/stage-submissions/[id]/route.ts
import { NextRequest, NextResponse } from "next/server"
import { getServerSession } from "next-auth/next"
import { authOptions } from "@/app/api/auth/[...nextauth]/route"
import db from "@/db/db"
import { stageSubmissions, stageSubmissionAttachments } from "@/db/schema"
import { eq, and } from "drizzle-orm"

export async function GET(
  request: NextRequest,
  { params }: { params: { id: string } }
) {
  try {
    const session = await getServerSession(authOptions)
    if (!session?.user?.companyId) {
      return NextResponse.json({ error: "Unauthorized" }, { status: 401 })
    }
    
    const vendorId = session.user.companyId
    const submissionId = parseInt(params.id)
    
    if (isNaN(submissionId)) {
      return NextResponse.json({ error: "Invalid submission ID" }, { status: 400 })
    }
    
    // submission 정보 조회 (벤더 검증 포함)
    const submission = await db
      .select()
      .from(stageSubmissions)
      .where(
        and(
          eq(stageSubmissions.id, submissionId),
          eq(stageSubmissions.vendorId, vendorId)
        )
      )
      .limit(1)
    
    if (submission.length === 0) {
      return NextResponse.json(
        { error: "Submission not found" }, 
        { status: 404 }
      )
    }
    
    // 첨부 파일 조회
    const files = await db
      .select({
        id: stageSubmissionAttachments.id,
        originalFileName: stageSubmissionAttachments.originalFileName,
        fileSize: stageSubmissionAttachments.fileSize,
        uploadedAt: stageSubmissionAttachments.uploadedAt,
        syncStatus: stageSubmissionAttachments.syncStatus,
        storageUrl: stageSubmissionAttachments.storageUrl,
        fileType: stageSubmissionAttachments.fileType,
        status: stageSubmissionAttachments.status,
      })
      .from(stageSubmissionAttachments)
      .where(eq(stageSubmissionAttachments.submissionId, submissionId))
      .orderBy(stageSubmissionAttachments.uploadedAt)
    
    // 응답 데이터 구성
    const result = {
      id: submission[0].id,
      revisionNumber: submission[0].revisionNumber,
      submissionStatus: submission[0].submissionStatus,
      reviewStatus: submission[0].reviewStatus,
      reviewComments: submission[0].reviewComments,
      submittedBy: submission[0].submittedBy,
      submittedAt: submission[0].submittedAt,
      submissionTitle: submission[0].submissionTitle,
      submissionDescription: submission[0].submissionDescription,
      files: files.filter(f => f.status === "ACTIVE"), // 활성 파일만
    }
    
    return NextResponse.json(result)
    
  } catch (error) {
    console.error("Error fetching submission detail:", error)
    return NextResponse.json(
      { error: "Internal server error" },
      { status: 500 }
    )
  }
}